Model Table REPORTING PERIOD

Attributes

Attribute Description (where applicable)
CompanyThe company identity.
Company-DateDefined as the COMPANY + ' - ' + REPORTING DATE
Reporting DateThe REPORTING_DATE without a time stamp.
Reporting Period DescrThe description of the reporting period associated with Company and Reporting Date (RPD_ID_DESCRIPTION)
Reporting Period NoThe reporting period (number) associated with Company and Reporting Date (RPD_PERIOD)
Reporting YearThe reporting year associated with Company and Reporting Date (RPD_YEAR)
Reporting YearPeriodThe reporting year (RPD_YEAR) and period (RPD_PERIOD), associated with Company and Reporting Date, concatenated as a number in the format YYYYMM

Hierarchies

Hierarchy Level
RepPeriodFHy
Company
Reporting Year
Reporting Period No
Reporting Date
Company-Date
RepPeriodSHy
Company
Reporting Year
Reporting Period No

USED BY MODEL(S)

Model Name
Crm
General Ledger
Group Consolidation
Incident Analysis
Maintenance
Procurement
Production Performance
Project
Sales

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
REPORTING PERIODDIM_REPORTING_PERIOD_MAINTENANCE_TMDIM_RDP_COMPANY_PERIOD_BIDIM_REPORTING_PERIOD_MAINTENANCEOn Line